package com.itheima.tlias84.mapper;

import com.itheima.tlias84.entity.Expr;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ExprMapper {

    int batchInsertExpr(@Param("list") List<Expr> list);

    int batchDeleteExpr(@Param("list") List<Integer> list);

    @Select("select id,company,job,emp_id,`begin`,`end` from expr where emp_id=#{empId}")
    List<Expr> selectExprByEmpId(@Param(("empId")) Integer empId);


}
